{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 推荐规则  \n",
    "-v1.2 李昱辰  \n",
    "1.添加用户影响因素  \n",
    "2.添加用户联系系数  \n",
    "3.修正模型为可控模型\n",
    "  \n",
    "\n",
    "### 一. 用户标签规则  \n",
    "##### 规则一：每个用户的好友(或粉丝)中与该用户具有相同兴趣的人占多数  \n",
    "##### 规则二：与用户越相似的好友或粉丝，其标签越可能是用户的标签  \n",
    "##### 规则三：用户与某好友互动频率越高，用户与该好友的兴趣相似度越大（包括评论、动态、聊天）  \n",
    "\n",
    "因为APP注册过程并没有强制性的添加兴趣爱好，所以用户一些相对标签无法获得，只能获得用户地址，学校，专业，毕业时间等。  \n",
    "这个时候需要给用户一些默认的标签，按照用户所在学校的人群大类兴趣，从学校的用户的已有数据，进行推导，把大类标签作为用户的默认标签。\n",
    "\n",
    "1.学校标签  \n",
    "通过学校的共同性进行推荐，清华的学生更多地推荐清华的学生  \n",
    "\n",
    "2.专业标签  \n",
    "通过专业的共同性进行推荐，但是因为有很多交叉学科（比如UI设计就是设计和心理学、计算机的交叉学科，这样可以给用户打上不同的用户标签，推荐多个设计、心理学、计算机的个集或者交集的用户）、相同大类用户（比如文科类用户推荐文科用户、理科类用户推荐理科用户、工科推荐工科或者理科用户） \n",
    "\n",
    "3.学院标签\n",
    "通过学院的共同性进行推荐，经济学院的学生更容易和经济学院的学生形成交流\n",
    "\n",
    "3.年限推荐  \n",
    "大学四年时间内，所接触到的各个年级学生，更容易成为密集交流者  \n",
    "  \n",
    "4.兴趣推荐  \n",
    "1)用户设定兴趣的推荐  \n",
    "  通过用户自己设定的兴趣进行推荐，但是因为用户的“设定行为”具有不确定性，所以对于用户的准确的兴趣有一定的标准差。  \n",
    "2)用户行为兴趣的推荐  \n",
    "  ①用户好友的兴趣标签：取出现最多的几个标签作为用户隐性标签。  \n",
    "  ②用户参与活动的兴趣标签：因为活动没有设定标签，可以通过参与用户中出现最多的几个标签，作为活动的标签，这样也可返回为用户兴趣标签。\n",
    "\n",
    "### 二.用户价值\n",
    "用户价值暂时定为用户使用频率（单日内打开次数）、用户使用时长（单日内所有时长）、用户影响指数（动态被参与次数，如转发、评论、点赞等）  \n",
    "\n",
    "#### 1.使用频率与用户使用时长  \n",
    "用以衡定用户活跃度，如果长时间没有使用，那么用户对于平台的价值会下降。  \n",
    "\n",
    "#### 2.用户影响指数  \n",
    "##### 规则一：影响力越高的用户回复的动态的影响力越高，从而使该动态主人的影响力变高。  \n",
    "  \n",
    "##### 规则二：影响力越高的用户转发的动态的影响力越高，从而使该动态原创作者的影响力变高。  \n",
    "  \n",
    "##### 规则三：影响力越高的用户倾向于在其动态中@影响力高或者的用户。  \n",
    "  \n",
    "PageRank算法：  \n",
    "1.赋予所有用户相同的权重。  \n",
    "2.将每个用户的影响力权重按照其关注的人数等量分配  \n",
    "3.对每个用户来说，其影响力等于其粉丝分配给他的权重之和  \n",
    "4.第2步和第3步迭代，直到权重不再发生大的变化为止  \n",
    "\n",
    "运用pagerank算法，可以计算出不同的用户，不同的影响力权重。\n",
    "但是这个权重有很大的不稳定性，如果有人因为一些原因，关注的人和好友突涨，那么整体的影响力会上升特别快。\n",
    "用户的影响力除了他的动态关系之外，还与他的个人属性有很大的关系，比如动态的质量。动态的质量可以采用其被转发的数目、被回复的数目、被点赞的数目来得到。\n",
    "\n",
    "### 三.用户相似度\n",
    "运用余弦相似度来衡定用户的相似性，加入权重因素，让衡定结果更准确。  \n",
    "\n",
    "##### 1.余弦相似度\n",
    "余弦夹角公式： \n",
    "$$ \\cos\\theta = \\frac{\\alpha*\\beta}{|\\alpha|·|\\beta|} $$  \n",
    "\n",
    "公式变形后：\n",
    "$$ \\cos\\theta = \\frac{\\alpha*\\beta}{\\sqrt{\\alpha^2}·\\sqrt{\\beta^2}} $$\n",
    "\n",
    "运用：   \n",
    "  \n",
    " 用户  |  学校  |  专业  | 兴趣大类 | 兴趣小类  \n",
    "user1 | 锦城大学| 经济学 |   体育   |  足球  \n",
    "user2 | 锦城大学| 保险学 |   体育   |  足球  \n",
    "\n",
    "转换为用户矩阵：  \n",
    " 用户  |  锦城大学  |  经济学  |  保险学  |  体育  |  足球  \n",
    "user1 |      1    |    1    |    0    |   1   |    1  \n",
    "user2 |      1    |    0    |    1    |   1   |    1  \n",
    "\n",
    "则两个用户的相似度为：\n",
    "$$\\because \\cos\\theta = \\frac{1\\times1+1\\times0+0\\times1+1\\times1+1\\times1}{\\sqrt{1^2+1^2+0^2+1^2+1^2}\\times\\sqrt{1^2+0^2+1^2+1^2+1^2}} $$  \n",
    "\n",
    "$$\\therefore \\cos\\theta = \\frac{3}{4} = 0.75$$  \n",
    "\n",
    "权重算法：对于大类加上权重，比如锦城大学、比如体育  \n",
    " 用户  |  锦城大学  |  经济学  |  保险学  |  体育  |  足球  \n",
    "user1 |      2    |    1    |    0    |   2   |    1  \n",
    "user2 |      2    |    0    |    1    |   2   |    1  \n",
    "\n",
    "$$\\because \\cos\\theta = \\frac{2\\times2+1\\times0+0\\times1+2\\times2+1\\times1}{\\sqrt{2^2+1^2+0^2+2^2+1^2}\\times\\sqrt{2^2+0^2+1^2+2^2+1^2}} $$  \n",
    "\n",
    "$$\\therefore \\cos\\theta = \\frac{9}{10} = 0.9$$  \n",
    "  \n",
    "加上权重过后，相同的会表现出更好的相同性，但是不同的，就会有更大的差异性。  \n",
    "##### 2.余弦相似度变形  \n",
    "对于公式再理解，可以看出其实就是相同的特征在所有的特征中的占比。  \n",
    "\n",
    "$$\\because \\cos\\theta = \\frac{相同的特征}{所有特征} $$  \n",
    "$$\\therefore \\cos\\theta = \\frac{user1_s\\bigcap user2_s}{user1_s\\bigcup user2_s}$$\n",
    "\n",
    "### 四.用户联系系数  \n",
    "##### 1.用户互动系数  \n",
    "用户互动系数为不同用户之间的交流系数，包括用户的所有互动（交流、评论、点赞、转发、参与）  \n",
    "\n",
    "$$ \n",
    "设 交流为X_1、评论为X_2、转发为X_3、点赞为X_4、参与X_5,  \n",
    "\\therefore \\lambda_1>\\lambda_2>\\lambda_3>\\lambda_4>\\lambda_5\n",
    "$$  \n",
    "$$\n",
    "用户互动系数 = \\log\\sum^n(\\lambda_1 X_1 + \\lambda_2 X_2+\\lambda_3 X_3+\\lambda_4 X_4+\\lambda_5 X_5)\n",
    "$$  \n",
    "\n",
    "##### 2.用户联系系数 （用户互动相似系数）\n",
    "用户A有两个互动系数较高用户B与用户C，用户B和用户A的互动系数等于30，用户C与用户A的互动系数等于31，则用户B到用户A的互动相似系数为30/31=0.96   \n",
    "$$  \n",
    "设 A\\to B = 30,C\\to B =31\n",
    "$$  \n",
    "$$\n",
    "用户联系系数 = \\frac{min(A\\to B,C\\to B)}{max(A\\to B,C\\to B)}\n",
    "$$   \n",
    "\n",
    "这样推荐出来的用户，更容易三人为团，形成一个社交圈  \n",
    "\n",
    "### 五.推荐系数  \n",
    "推荐系数的构建包含了用户价值、用户联系系数、用户相似度三个参数的结合，根据不同的运营场景，可以调整参数的权重用以适应。  \n",
    "  \n",
    "## $$推荐系数 = \\log(\\lambda_1 * 用户联系系数 + \\lambda_2 * 用户价值 + \\lambda_3 * 用户相似度)$$"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Q&A\n",
    "#### Q：1.用户标签如何标记和构建？  \n",
    "  \n",
    "A：初始的时候会根据用户的填写，如学校、专业、学年来构建特征、用户也可以在兴趣爱好里填写自己的兴趣爱好，但考虑到兴趣爱好的变化性、用户资料的主观性以及填写信息的时间敏感性，则按照用户行为（如用户点赞、评论、转发、参与动态、参与活动、交友圈的隐性标签作为用户较为客观的）来构建。  \n",
    "  \n",
    "#### Q：2.用户价值为什么要引入用户影响指数？  \n",
    "  \n",
    "A：用户影响指数是要在APP中推荐发文质量较高，关注人数较多的用户，这样的用户可以带动整个平台的质量和活跃性，也可以激活普通用户成为“大V”用户。  \n",
    "#### Q：3.用户联系系数的意义在哪？  \n",
    "  \n",
    "A：比如A有B和C两个密切联系好友，那么B和C是有互相认识的意义的，这样有助于生成更加密切用户社交网络，而不是散开的形式。  \n",
    "  \n",
    "#### Q：4. 推荐系数的三个权重参数如何进行选择？   \n",
    "  \n",
    "A：按照运营策略进行选择：  \n",
    "   (1)如果是推进高质量用户、以及主打质量内容，则可以主要加大用户价值的权重。  \n",
    "   (2)如果在前期，用户好友较少，单用户的交流互动较少，则可以主要加大用户相似度的权重。  \n",
    "   (3)如果平台要形成用户交流圈子，以及刺激一些线下活动的活跃（普遍人群号召比个人意愿更会参加活动板块），则可以主要加大用户联系系数的权重。  "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 示例\n",
    "\n",
    "python 3.6.2 -jupyter notebook"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#导入所需要的包\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "%matplotlib inline\n",
    "\n",
    "#读取数据，并对数据做初始处理\n",
    "user_data = pd.read_csv('../data/user_data.csv')\n",
    "user_data = user_data.drop('Unnamed: 0',axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 创建模拟用户"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "userA = pd.Series([\n",
    "    101,\n",
    "    '四川',\n",
    "    '成都市',\n",
    "    '西华大学',\n",
    "    '经济学院',\n",
    "    '文学',\n",
    "    '经济学',\n",
    "    '影视',\n",
    "    '美丽人生',\n",
    "    '2011',\n",
    "    '技能',\n",
    "    '编程',\n",
    "    '名人',\n",
    "    '搞笑漫画日和',\n",
    "    '宋冬野',\n",
    "    '搞笑漫画日和',\n",
    "    '妖精的尾巴',\n",
    "    '七龙珠',\n",
    "    '搞笑漫画日和'\n",
    "])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "构建虚拟用户互动系数和用户价值  \n",
    "- 用户系数 1-9\n",
    "- 用户价值 1-9"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['similarity'] = ''\n",
    "score_list = []\n",
    "userA_set = set(userA)\n",
    "userB_set = set(userA)\n",
    "\n",
    "for i in range(0,len(user_data)):\n",
    "    userB_set = set(user_data.loc[i])\n",
    "    score = len(userA_set&userB_set)/(np.sqrt(len(userA_set))*np.sqrt(len(userB_set)))\n",
    "    score_list.append(score)\n",
    "    \n",
    "user_data['similarity'] = score_list\n",
    "\n",
    "user_data['value'] = ''\n",
    "user_data['value'] = user_data['value'].apply(lambda x : np.random.choice(range(1,10)))\n",
    "\n",
    "user_data['connect'] = ''\n",
    "user_data['connect'] = user_data['connect'].apply(lambda x : np.random.choice(range(1,10)))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### $$ 推荐系数 = \\log(\\lambda_1 * 互动系数 + \\lambda_2 * 用户价值 + \\lambda_3 * 用户相似度) $$"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "user_data['score'] = ''\n",
    "for i in range(0,len(user_data)):\n",
    "    #核心算法，权重可修改进行推荐，现设置互动系数权重为0.2、用户价值权重位0.2、用户相似度权重为0.2\n",
    "    user_data['score'][i] = np.log10(0.2*user_data['connect'][i]+0.2*user_data['value'][i]+0.2*60*user_data['similarity'][i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>region_parent</th>\n",
       "      <th>region_detail</th>\n",
       "      <th>school_parent</th>\n",
       "      <th>school_detail</th>\n",
       "      <th>major_parent</th>\n",
       "      <th>major_detail</th>\n",
       "      <th>interest_parent</th>\n",
       "      <th>interest_detail</th>\n",
       "      <th>interest_parent1</th>\n",
       "      <th>...</th>\n",
       "      <th>interest_detail2</th>\n",
       "      <th>year</th>\n",
       "      <th>interest_detail3</th>\n",
       "      <th>interest_detail4</th>\n",
       "      <th>interest_detail5</th>\n",
       "      <th>interest_detail6</th>\n",
       "      <th>similarity</th>\n",
       "      <th>value</th>\n",
       "      <th>connect</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>10154</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>影视</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>2008</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>0.647059</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>1.01556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>10069</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>金融学</td>\n",
       "      <td>名人</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>霸王别姬</td>\n",
       "      <td>2005</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>0.352941</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0.894055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>10232</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>动漫</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>2007</td>\n",
       "      <td>笑傲江湖</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>0.333849</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0.881167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521</th>\n",
       "      <td>10521</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>美食</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>2001</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>0.352941</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>0.859456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>10213</td>\n",
       "      <td>四川</td>\n",
       "      <td>内江市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>技能</td>\n",
       "      <td>编程</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>2004</td>\n",
       "      <td>死神</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>0.400163</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0.857451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>10996</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>土木工程</td>\n",
       "      <td>名人</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>2013</td>\n",
       "      <td>寻梦幻游记</td>\n",
       "      <td>霸王别姬</td>\n",
       "      <td>终结者</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>0.333849</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>0.845482</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>713</th>\n",
       "      <td>10713</td>\n",
       "      <td>四川</td>\n",
       "      <td>雅安市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>国际经济与贸易</td>\n",
       "      <td>综艺</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>摄影</td>\n",
       "      <td>2008</td>\n",
       "      <td>文案</td>\n",
       "      <td>文案</td>\n",
       "      <td>料理</td>\n",
       "      <td>编程</td>\n",
       "      <td>0.400163</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>0.84522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>10348</td>\n",
       "      <td>四川</td>\n",
       "      <td>眉山市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>技能</td>\n",
       "      <td>书法</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>写作</td>\n",
       "      <td>2004</td>\n",
       "      <td>策划</td>\n",
       "      <td>文案</td>\n",
       "      <td>设计</td>\n",
       "      <td>书法</td>\n",
       "      <td>0.313112</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0.842444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>799</th>\n",
       "      <td>10799</td>\n",
       "      <td>四川</td>\n",
       "      <td>达州市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>软件工程</td>\n",
       "      <td>影视</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>2013</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>林允</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>GALA</td>\n",
       "      <td>0.278207</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0.841265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>10104</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>艺术学院</td>\n",
       "      <td>艺术学</td>\n",
       "      <td>表演</td>\n",
       "      <td>美食</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>2005</td>\n",
       "      <td>霸王别姬</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>0.278207</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0.841265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>10051</td>\n",
       "      <td>四川</td>\n",
       "      <td>雅安市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>国际经济与贸易</td>\n",
       "      <td>综艺</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>策划</td>\n",
       "      <td>2017</td>\n",
       "      <td>花艺</td>\n",
       "      <td>策划</td>\n",
       "      <td>编程</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>0.342997</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>0.839853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10004</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>影视</td>\n",
       "      <td>一代宗师</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>2013</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>黄子韬</td>\n",
       "      <td>0.352941</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>0.834757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>10148</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>影视</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>2015</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>0.285831</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>0.834419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>10649</td>\n",
       "      <td>四川</td>\n",
       "      <td>攀枝花市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>金融学</td>\n",
       "      <td>技能</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>2014</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>张瀚</td>\n",
       "      <td>吴亦凡</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>0.333849</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>0.832904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>10829</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>综艺</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>文案</td>\n",
       "      <td>2001</td>\n",
       "      <td>摄影</td>\n",
       "      <td>花艺</td>\n",
       "      <td>绘画</td>\n",
       "      <td>书法</td>\n",
       "      <td>0.400163</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>0.832634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>10992</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>文学与传媒学院</td>\n",
       "      <td>文学</td>\n",
       "      <td>行政管理</td>\n",
       "      <td>名人</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>绘画</td>\n",
       "      <td>2017</td>\n",
       "      <td>编程</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>料理</td>\n",
       "      <td>料理</td>\n",
       "      <td>0.400163</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>0.832634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>10156</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>保险学</td>\n",
       "      <td>影视</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>2011</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>0.278207</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>0.828563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>10744</td>\n",
       "      <td>四川</td>\n",
       "      <td>攀枝花市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>人力资源</td>\n",
       "      <td>动漫</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>春娇与志明</td>\n",
       "      <td>2016</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>漫威</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>0.278207</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>0.828563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>10330</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>国际经济与贸易</td>\n",
       "      <td>名人</td>\n",
       "      <td>黄子韬</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>鱼香肉丝</td>\n",
       "      <td>2007</td>\n",
       "      <td>火锅</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>鱼香肉丝</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>0.294118</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0.827977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>558</th>\n",
       "      <td>10558</td>\n",
       "      <td>四川</td>\n",
       "      <td>雅安市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>审计</td>\n",
       "      <td>名人</td>\n",
       "      <td>周杰伦</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>2007</td>\n",
       "      <td>周杰伦</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>0.294118</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>0.827977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>10985</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>名人</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>绘画</td>\n",
       "      <td>2010</td>\n",
       "      <td>编程</td>\n",
       "      <td>摄影</td>\n",
       "      <td>策划</td>\n",
       "      <td>文案</td>\n",
       "      <td>0.457330</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0.825293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>10360</td>\n",
       "      <td>四川</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>影视</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>2012</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>0.352941</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>0.82186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>704</th>\n",
       "      <td>10704</td>\n",
       "      <td>四川</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>财务管理</td>\n",
       "      <td>技能</td>\n",
       "      <td>摄影</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>帕丁顿熊</td>\n",
       "      <td>2011</td>\n",
       "      <td>终结者</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>0.285831</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0.821512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>963</th>\n",
       "      <td>10963</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>财务管理</td>\n",
       "      <td>技能</td>\n",
       "      <td>料理</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>张瀚</td>\n",
       "      <td>2006</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>新垣结衣</td>\n",
       "      <td>0.278207</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>0.815477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>10737</td>\n",
       "      <td>四川</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>金融学</td>\n",
       "      <td>综艺</td>\n",
       "      <td>蒙面唱将猜猜猜</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>2013</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>0.294118</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>0.814874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>10451</td>\n",
       "      <td>四川</td>\n",
       "      <td>达州市</td>\n",
       "      <td>四川大学锦城学院</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>名人</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>花艺</td>\n",
       "      <td>2012</td>\n",
       "      <td>绘画</td>\n",
       "      <td>绘画</td>\n",
       "      <td>文案</td>\n",
       "      <td>设计</td>\n",
       "      <td>0.294118</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>0.814874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636</th>\n",
       "      <td>10636</td>\n",
       "      <td>四川</td>\n",
       "      <td>遂宁市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>土木工程</td>\n",
       "      <td>动漫</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>吴亦凡</td>\n",
       "      <td>2014</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>新垣结衣</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>0.342997</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>0.813979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>10216</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>人力资源</td>\n",
       "      <td>技能</td>\n",
       "      <td>编程</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>2009</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>新垣结衣</td>\n",
       "      <td>0.303170</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>0.808753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>10313</td>\n",
       "      <td>四川</td>\n",
       "      <td>绵阳市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>电气学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>电气工程</td>\n",
       "      <td>技能</td>\n",
       "      <td>料理</td>\n",
       "      <td>名人</td>\n",
       "      <td>...</td>\n",
       "      <td>漫威</td>\n",
       "      <td>2017</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>0.285831</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>0.808209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>880</th>\n",
       "      <td>10880</td>\n",
       "      <td>四川</td>\n",
       "      <td>遂宁市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>技能</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>2007</td>\n",
       "      <td>无头骑士异闻录</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>0.235294</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0.807774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>10581</td>\n",
       "      <td>四川</td>\n",
       "      <td>南充市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>综艺</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>2004</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>0.114332</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.336858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>10701</td>\n",
       "      <td>四川</td>\n",
       "      <td>泸州市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>综艺</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>蒙面唱将猜猜猜</td>\n",
       "      <td>2014</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>笑傲江湖</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>0.114332</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0.336858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>10946</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>软件工程</td>\n",
       "      <td>美食</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>2011</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>0.114332</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0.336858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>719</th>\n",
       "      <td>10719</td>\n",
       "      <td>四川</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>人力资源</td>\n",
       "      <td>美食</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>2005</td>\n",
       "      <td>热血街舞团</td>\n",
       "      <td>创造101</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>0.111283</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.329478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>10598</td>\n",
       "      <td>四川</td>\n",
       "      <td>绵阳市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>网络工程</td>\n",
       "      <td>综艺</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>2017</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>0.058824</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0.323434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>10268</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>名人</td>\n",
       "      <td>周杰伦</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>2016</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>漫威</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>0.125245</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.322827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>10327</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>会计</td>\n",
       "      <td>技能</td>\n",
       "      <td>设计</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>2017</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>0.125245</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.322827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>10200</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>审计</td>\n",
       "      <td>影视</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>2003</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>0.057166</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0.319313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>10752</td>\n",
       "      <td>四川</td>\n",
       "      <td>南充市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>名人</td>\n",
       "      <td>吴亦凡</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>杨幂</td>\n",
       "      <td>2011</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>黄子韬</td>\n",
       "      <td>0.117647</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.303577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>679</th>\n",
       "      <td>10679</td>\n",
       "      <td>四川</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>动漫</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>2016</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>0.117647</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.303577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>10510</td>\n",
       "      <td>四川</td>\n",
       "      <td>南充市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>技能</td>\n",
       "      <td>书法</td>\n",
       "      <td>技能</td>\n",
       "      <td>...</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>2011</td>\n",
       "      <td>死神</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>死神</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>0.117647</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.303577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>10058</td>\n",
       "      <td>四川</td>\n",
       "      <td>南充市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>网络工程</td>\n",
       "      <td>影视</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>2005</td>\n",
       "      <td>寿司</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>0.114332</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.294904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>583</th>\n",
       "      <td>10583</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>人力资源</td>\n",
       "      <td>美食</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>2011</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>0.058824</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0.280096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>10468</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>影视</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>2000</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>热血街舞团</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>0.058824</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.280096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>542</th>\n",
       "      <td>10542</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>四川大学锦城学院</td>\n",
       "      <td>机械学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>机械电子工程</td>\n",
       "      <td>动漫</td>\n",
       "      <td>死神</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>2002</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>张瀚</td>\n",
       "      <td>0.057166</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0.27554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>703</th>\n",
       "      <td>10703</td>\n",
       "      <td>四川</td>\n",
       "      <td>巴中市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>动漫</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>2002</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>档案</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>0.057166</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0.27554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>10167</td>\n",
       "      <td>四川</td>\n",
       "      <td>遂宁市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>动漫</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>2000</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>无头骑士异闻录</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>0.057166</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0.27554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>10132</td>\n",
       "      <td>四川</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>网络工程</td>\n",
       "      <td>动漫</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>2008</td>\n",
       "      <td>寿司</td>\n",
       "      <td>串串香</td>\n",
       "      <td>寿司</td>\n",
       "      <td>鱼香肉丝</td>\n",
       "      <td>0.057166</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>0.27554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>10347</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>建筑学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑学</td>\n",
       "      <td>美食</td>\n",
       "      <td>串串香</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>文案</td>\n",
       "      <td>2013</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>摄影</td>\n",
       "      <td>摄影</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>0.121268</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.268394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <td>10367</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>美食</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>花艺</td>\n",
       "      <td>2006</td>\n",
       "      <td>花艺</td>\n",
       "      <td>摄影</td>\n",
       "      <td>设计</td>\n",
       "      <td>设计</td>\n",
       "      <td>0.117647</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.258102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657</th>\n",
       "      <td>10657</td>\n",
       "      <td>四川</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>技能</td>\n",
       "      <td>书法</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>2001</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>0.117647</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.258102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10001</td>\n",
       "      <td>四川</td>\n",
       "      <td>眉山市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>综艺</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>美食</td>\n",
       "      <td>...</td>\n",
       "      <td>花艺</td>\n",
       "      <td>2013</td>\n",
       "      <td>书法</td>\n",
       "      <td>摄影</td>\n",
       "      <td>写作</td>\n",
       "      <td>写作</td>\n",
       "      <td>0.114332</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.248461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>10041</td>\n",
       "      <td>四川</td>\n",
       "      <td>资阳市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>动漫</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>2007</td>\n",
       "      <td>创造101</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>0.058824</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.231949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>630</th>\n",
       "      <td>10630</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>动漫</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>2008</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>创造101</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>0.058824</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.231949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690</th>\n",
       "      <td>10690</td>\n",
       "      <td>四川</td>\n",
       "      <td>内江市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>美食</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>创造101</td>\n",
       "      <td>2004</td>\n",
       "      <td>档案</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>0.057166</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0.226856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>10170</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>土木工程</td>\n",
       "      <td>名人</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>2012</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>0.060634</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.184012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>865</th>\n",
       "      <td>10865</td>\n",
       "      <td>四川</td>\n",
       "      <td>巴中市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>美食</td>\n",
       "      <td>串串香</td>\n",
       "      <td>综艺</td>\n",
       "      <td>...</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>2013</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>0.060634</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.123069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>10478</td>\n",
       "      <td>四川</td>\n",
       "      <td>资阳市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>综艺</td>\n",
       "      <td>蒙面唱将猜猜猜</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>2000</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>笑傲江湖</td>\n",
       "      <td>0.058824</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.115904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>10088</td>\n",
       "      <td>四川</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>综艺</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>动漫</td>\n",
       "      <td>...</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>2010</td>\n",
       "      <td>火锅</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>0.057166</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0358276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>10231</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>综艺</td>\n",
       "      <td>笑傲江湖</td>\n",
       "      <td>影视</td>\n",
       "      <td>...</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>2006</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>火锅</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>0.057166</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0358276</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id region_parent region_detail school_parent school_detail  \\\n",
       "154  10154            四川           成都市          西华大学          经济学院   \n",
       "69   10069            四川           成都市        四川师范大学          经济学院   \n",
       "232  10232            四川           成都市          西华大学          管理学院   \n",
       "521  10521            四川           成都市        西南石油大学          经济学院   \n",
       "213  10213            四川           内江市        西南财经大学          经济学院   \n",
       "996  10996            四川           成都市        成都理工大学     土木与环境工程学院   \n",
       "713  10713            四川           雅安市      成都信息工程大学          经济学院   \n",
       "348  10348            四川           眉山市          西华大学          经济学院   \n",
       "799  10799            四川           达州市        四川师范大学         计算机学院   \n",
       "104  10104            四川           成都市        四川师范大学          艺术学院   \n",
       "51   10051            四川           雅安市          西华大学          经济学院   \n",
       "4    10004            四川           德阳市      成都信息工程大学          经济学院   \n",
       "148  10148            四川           德阳市        电子科技大学          经济学院   \n",
       "649  10649            四川          攀枝花市          四川大学          经济学院   \n",
       "829  10829            四川           成都市          西华大学          经济学院   \n",
       "992  10992            四川           自贡市      成都信息工程大学       文学与传媒学院   \n",
       "156  10156            四川           广元市      成都信息工程大学          经济学院   \n",
       "744  10744            四川          攀枝花市        西南财经大学          管理学院   \n",
       "330  10330            四川           成都市        电子科技大学          经济学院   \n",
       "558  10558            四川           雅安市          西华大学        财务会计学院   \n",
       "985  10985            四川           成都市        成都理工大学          经济学院   \n",
       "360  10360            四川           宜宾市        四川师范大学          经济学院   \n",
       "704  10704            四川           乐山市        电子科技大学        财务会计学院   \n",
       "963  10963            四川           自贡市        西南交通大学        财务会计学院   \n",
       "737  10737            四川           乐山市        西南交通大学          经济学院   \n",
       "451  10451            四川           达州市      四川大学锦城学院          经济学院   \n",
       "636  10636            四川           遂宁市          西华大学     土木与环境工程学院   \n",
       "216  10216            四川           德阳市        成都理工大学          管理学院   \n",
       "313  10313            四川           绵阳市          西华大学          电气学院   \n",
       "880  10880            四川           遂宁市        西南石油大学          管理学院   \n",
       "..     ...           ...           ...           ...           ...   \n",
       "581  10581            四川           南充市        西南石油大学          管理学院   \n",
       "701  10701            四川           泸州市          西华大学     土木与环境工程学院   \n",
       "946  10946            四川           广元市        西南财经大学         计算机学院   \n",
       "719  10719            四川           宜宾市        成都理工大学          管理学院   \n",
       "598  10598            四川           绵阳市          四川大学         计算机学院   \n",
       "268  10268            重庆            重庆          四川大学          管理学院   \n",
       "327  10327            重庆            重庆        西南石油大学        财务会计学院   \n",
       "200  10200            重庆            重庆          四川大学        财务会计学院   \n",
       "752  10752            四川           南充市      成都信息工程大学          管理学院   \n",
       "679  10679            四川           宜宾市        四川师范大学          管理学院   \n",
       "510  10510            四川           南充市        四川师范大学          管理学院   \n",
       "58   10058            四川           南充市          四川大学         计算机学院   \n",
       "583  10583            四川           广元市        西南石油大学          管理学院   \n",
       "468  10468            重庆            重庆        西南石油大学     土木与环境工程学院   \n",
       "542  10542            重庆            重庆      四川大学锦城学院          机械学院   \n",
       "703  10703            四川           巴中市        成都理工大学          管理学院   \n",
       "167  10167            四川           遂宁市        四川师范大学     土木与环境工程学院   \n",
       "132  10132            四川           宜宾市        西南交通大学         计算机学院   \n",
       "347  10347            重庆            重庆        西南石油大学          建筑学院   \n",
       "367  10367            四川           自贡市          四川大学          管理学院   \n",
       "657  10657            四川           乐山市        西南交通大学     土木与环境工程学院   \n",
       "1    10001            四川           眉山市        西南交通大学     土木与环境工程学院   \n",
       "41   10041            四川           资阳市        西南石油大学          管理学院   \n",
       "630  10630            四川           自贡市      成都信息工程大学          管理学院   \n",
       "690  10690            四川           内江市          四川大学          管理学院   \n",
       "170  10170            重庆            重庆        四川师范大学     土木与环境工程学院   \n",
       "865  10865            四川           巴中市        西南财经大学          管理学院   \n",
       "478  10478            四川           资阳市        西南石油大学     土木与环境工程学院   \n",
       "88   10088            四川           宜宾市        四川师范大学          管理学院   \n",
       "231  10231            重庆            重庆      成都信息工程大学          管理学院   \n",
       "\n",
       "    major_parent major_detail interest_parent interest_detail  \\\n",
       "154          经济学          经济学              影视            美丽人生   \n",
       "69           经济学          金融学              名人             赵丽颖   \n",
       "232          管理学         工商管理              动漫             七龙珠   \n",
       "521          经济学          经济学              美食            麻婆豆腐   \n",
       "213          经济学          经济学              技能              编程   \n",
       "996           工学         土木工程              名人            迪丽热巴   \n",
       "713          经济学      国际经济与贸易              综艺           演员的诞生   \n",
       "348          经济学          经济学              技能              书法   \n",
       "799           工学         软件工程              影视            环太平洋   \n",
       "104          艺术学           表演              美食             钵钵鸡   \n",
       "51           经济学      国际经济与贸易              综艺             奔跑吧   \n",
       "4            经济学          经济学              影视            一代宗师   \n",
       "148          经济学          经济学              影视           泰坦尼克号   \n",
       "649          经济学          金融学              技能            电子音乐   \n",
       "829          经济学          经济学              综艺           演员的诞生   \n",
       "992           文学         行政管理              名人             宋冬野   \n",
       "156          经济学          保险学              影视           复仇者联盟   \n",
       "744          管理学         人力资源              动漫             七龙珠   \n",
       "330          经济学      国际经济与贸易              名人             黄子韬   \n",
       "558          管理学           审计              名人             周杰伦   \n",
       "985          经济学          经济学              名人            迪丽热巴   \n",
       "360          经济学          经济学              影视            阿甘正传   \n",
       "704          管理学         财务管理              技能              摄影   \n",
       "963          管理学         财务管理              技能              料理   \n",
       "737          经济学          金融学              综艺         蒙面唱将猜猜猜   \n",
       "451          经济学          经济学              名人             张艺兴   \n",
       "636           工学         土木工程              动漫           妖精的尾巴   \n",
       "216          管理学         人力资源              技能              编程   \n",
       "313           工学         电气工程              技能              料理   \n",
       "880          管理学         市场营销              技能            电子音乐   \n",
       "..           ...          ...             ...             ...   \n",
       "581          管理学         市场营销              综艺            天天向上   \n",
       "701           工学       建筑工程技术              综艺           中国式相亲   \n",
       "946           工学         软件工程              美食              烤肉   \n",
       "719          管理学         人力资源              美食             豆腐脑   \n",
       "598           工学         网络工程              综艺           快乐大本营   \n",
       "268          管理学         市场营销              名人             周杰伦   \n",
       "327          管理学           会计              技能              设计   \n",
       "200          管理学           审计              影视           泰坦尼克号   \n",
       "752          管理学         工商管理              名人             吴亦凡   \n",
       "679          管理学         市场营销              动漫             海贼王   \n",
       "510          管理学         市场营销              技能              书法   \n",
       "58            工学         网络工程              影视           复仇者联盟   \n",
       "583          管理学         人力资源              美食            麻婆豆腐   \n",
       "468           工学       建筑工程技术              影视            让子弹飞   \n",
       "542           工学       机械电子工程              动漫              死神   \n",
       "703          管理学         市场营销              动漫         喜羊羊和灰太狼   \n",
       "167           工学       建筑工程技术              动漫            火影忍者   \n",
       "132           工学         网络工程              动漫            灌篮高手   \n",
       "347           工学          建筑学              美食             串串香   \n",
       "367          管理学         市场营销              美食            糖醋排骨   \n",
       "657           工学       建筑工程技术              技能              书法   \n",
       "1             工学       建筑工程技术              综艺            非诚勿扰   \n",
       "41           管理学         工商管理              动漫           命运石之门   \n",
       "630          管理学         市场营销              动漫           命运石之门   \n",
       "690          管理学         工商管理              美食            糖醋排骨   \n",
       "170           工学         土木工程              名人             冯小刚   \n",
       "865          管理学         市场营销              美食             串串香   \n",
       "478           工学       建筑工程技术              综艺         蒙面唱将猜猜猜   \n",
       "88           管理学         工商管理              综艺           快乐大本营   \n",
       "231          管理学         工商管理              综艺            笑傲江湖   \n",
       "\n",
       "    interest_parent1    ...     interest_detail2  year interest_detail3  \\\n",
       "154               技能    ...               辛普森的一家  2008           搞笑漫画日和   \n",
       "69                名人    ...                 霸王别姬  2005              海豚湾   \n",
       "232               技能    ...                中国好声音  2007             笑傲江湖   \n",
       "521               动漫    ...                 环太平洋  2001              海豚湾   \n",
       "213               影视    ...                 灌篮高手  2004               死神   \n",
       "996               动漫    ...                 美丽人生  2013            寻梦幻游记   \n",
       "713               名人    ...                   摄影  2008               文案   \n",
       "348               技能    ...                   写作  2004               策划   \n",
       "799               技能    ...                  冯小刚  2013              赵丽颖   \n",
       "104               名人    ...                泰坦尼克号  2005             霸王别姬   \n",
       "51                美食    ...                   策划  2017               花艺   \n",
       "4                 影视    ...                  张艺兴  2013              宋冬野   \n",
       "148               美食    ...                  海贼王  2015             火影忍者   \n",
       "649               影视    ...                  赵丽颖  2014          泰勒·斯威夫特   \n",
       "829               动漫    ...                   文案  2001               摄影   \n",
       "992               影视    ...                   绘画  2017               编程   \n",
       "156               名人    ...                老梁故事汇  2011            演员的诞生   \n",
       "744               技能    ...                春娇与志明  2016             环太平洋   \n",
       "330               美食    ...                 鱼香肉丝  2007               火锅   \n",
       "558               技能    ...                  宋冬野  2007              周杰伦   \n",
       "985               影视    ...                   绘画  2010               编程   \n",
       "360               技能    ...                命运石之门  2012              海贼王   \n",
       "704               名人    ...                 帕丁顿熊  2011              终结者   \n",
       "963               影视    ...                   张瀚  2006              宋冬野   \n",
       "737               影视    ...               辛普森的一家  2013           辛普森的一家   \n",
       "451               美食    ...                   花艺  2012               绘画   \n",
       "636               动漫    ...                  吴亦凡  2014              张艺兴   \n",
       "216               名人    ...                   鹿晗  2009               鹿晗   \n",
       "313               名人    ...                   漫威  2017              海豚湾   \n",
       "880               美食    ...                  七龙珠  2007          无头骑士异闻录   \n",
       "..               ...    ...                  ...   ...              ...   \n",
       "581               影视    ...                  酸菜鱼  2004              酸菜鱼   \n",
       "701               美食    ...              蒙面唱将猜猜猜  2014            快乐大本营   \n",
       "946               综艺    ...                 灌篮高手  2011           辛普森的一家   \n",
       "719               影视    ...                 非诚勿扰  2005            热血街舞团   \n",
       "598               美食    ...                 非诚勿扰  2017             天天向上   \n",
       "268               影视    ...                  海豚湾  2016             阿甘正传   \n",
       "327               技能    ...               搞笑漫画日和  2017             火影忍者   \n",
       "200               综艺    ...              喜羊羊和灰太狼  2003             灌篮高手   \n",
       "752               综艺    ...                   杨幂  2011          泰勒·斯威夫特   \n",
       "679               影视    ...                  卤肉饭  2016             麻婆豆腐   \n",
       "510               技能    ...                 火影忍者  2011               死神   \n",
       "58                美食    ...                  卤肉饭  2005               寿司   \n",
       "583               动漫    ...                 糖醋排骨  2011              酸菜鱼   \n",
       "468               动漫    ...                中国式相亲  2000             非诚勿扰   \n",
       "542               美食    ...                  赵丽颖  2002               鹿晗   \n",
       "703               动漫    ...                真正男子汉  2002            快乐大本营   \n",
       "167               综艺    ...               辛普森的一家  2000            命运石之门   \n",
       "132               综艺    ...                   烤肉  2008               寿司   \n",
       "347               影视    ...                   文案  2013             电子音乐   \n",
       "367               综艺    ...                   花艺  2006               花艺   \n",
       "657               动漫    ...                  牛肉面  2001              卤肉饭   \n",
       "1                 美食    ...                   花艺  2013               书法   \n",
       "41                综艺    ...                  奔跑吧  2007            创造101   \n",
       "630               综艺    ...                我们十七岁  2008            中国好声音   \n",
       "690               动漫    ...                创造101  2004               档案   \n",
       "170               动漫    ...                 天天向上  2012            中国好声音   \n",
       "865               综艺    ...                  钵钵鸡  2013              牛肉面   \n",
       "478               动漫    ...                 非诚勿扰  2000            快乐大本营   \n",
       "88                动漫    ...                 麻婆豆腐  2010               火锅   \n",
       "231               影视    ...                  豆腐脑  2006              卤肉饭   \n",
       "\n",
       "     interest_detail4 interest_detail5 interest_detail6 similarity value  \\\n",
       "154             妖精的尾巴              七龙珠           搞笑漫画日和   0.647059     9   \n",
       "69              复仇者联盟              海豚湾             阿甘正传   0.352941     9   \n",
       "232             我们十七岁            老梁故事汇             天天向上   0.333849     9   \n",
       "521              美丽人生             阿甘正传             阿甘正传   0.352941     7   \n",
       "213               七龙珠            命运石之门              海贼王   0.400163     6   \n",
       "996              霸王别姬              终结者              海豚湾   0.333849     7   \n",
       "713                文案               料理               编程   0.400163     8   \n",
       "348                文案               设计               书法   0.313112     8   \n",
       "799                林允               鹿晗             GALA   0.278207     9   \n",
       "104             复仇者联盟             美丽人生             环太平洋   0.278207     9   \n",
       "51                 策划               编程             电子音乐   0.342997     9   \n",
       "4             泰勒·斯威夫特              冯小刚              黄子韬   0.352941     7   \n",
       "148           喜羊羊和灰太狼            命运石之门            妖精的尾巴   0.285831     8   \n",
       "649                张瀚              吴亦凡               鹿晗   0.333849     6   \n",
       "829                花艺               绘画               书法   0.400163     1   \n",
       "992              电子音乐               料理               料理   0.400163     4   \n",
       "156               奔跑吧            中国式相亲            中国好声音   0.278207     9   \n",
       "744                漫威             美丽人生              海豚湾   0.278207     8   \n",
       "330               卤肉饭             鱼香肉丝               烤肉   0.294118     8   \n",
       "558               张艺兴              赵丽颖             迪丽热巴   0.294118     7   \n",
       "985                摄影               策划               文案   0.457330     4   \n",
       "360               海贼王              七龙珠          喜羊羊和灰太狼   0.352941     5   \n",
       "704              让子弹飞             美丽人生             美丽人生   0.285831     8   \n",
       "963           泰勒·斯威夫特              赵丽颖             新垣结衣   0.278207     7   \n",
       "737            辛普森的一家              海贼王            妖精的尾巴   0.294118     8   \n",
       "451                绘画               文案               设计   0.294118     8   \n",
       "636               宋冬野             新垣结衣              冯小刚   0.342997     4   \n",
       "216               宋冬野               鹿晗             新垣结衣   0.303170     8   \n",
       "313               海豚湾             环太平洋            复仇者联盟   0.285831     7   \n",
       "880             妖精的尾巴              七龙珠              七龙珠   0.235294     9   \n",
       "..                ...              ...              ...        ...   ...   \n",
       "581               牛肉面               烤肉              豆腐脑   0.114332     2   \n",
       "701              笑傲江湖            真正男子汉            演员的诞生   0.114332     1   \n",
       "946            搞笑漫画日和           中国惊奇先生           搞笑漫画日和   0.114332     1   \n",
       "719             创造101            演员的诞生             天天向上   0.111283     2   \n",
       "598               奔跑吧            快乐大本营            真正男子汉   0.058824     6   \n",
       "268               海豚湾               漫威             阿甘正传   0.125245     2   \n",
       "327            辛普森的一家           辛普森的一家           搞笑漫画日和   0.125245     2   \n",
       "200               海贼王            命运石之门           中国惊奇先生   0.057166     4   \n",
       "752              迪丽热巴             迪丽热巴              黄子韬   0.117647     1   \n",
       "679               卤肉饭              酸菜鱼             麻婆豆腐   0.117647     1   \n",
       "510            中国惊奇先生               死神              海贼王   0.117647     1   \n",
       "58                钵钵鸡              牛肉面             麻婆豆腐   0.114332     2   \n",
       "583                烤肉              豆腐脑             糖醋排骨   0.058824     4   \n",
       "468             热血街舞团             非诚勿扰            真正男子汉   0.058824     1   \n",
       "542              迪丽热巴              冯小刚               张瀚   0.057166     4   \n",
       "703                档案            演员的诞生              奔跑吧   0.057166     5   \n",
       "167              灌篮高手          无头骑士异闻录              海贼王   0.057166     4   \n",
       "132               串串香               寿司             鱼香肉丝   0.057166     2   \n",
       "347                摄影               摄影             电子音乐   0.121268     1   \n",
       "367                摄影               设计               设计   0.117647     1   \n",
       "657               牛肉面              卤肉饭              钵钵鸡   0.117647     1   \n",
       "1                  摄影               写作               写作   0.114332     1   \n",
       "41               天天向上            我们十七岁            我们十七岁   0.058824     3   \n",
       "630             真正男子汉            创造101            我们十七岁   0.058824     3   \n",
       "690             老梁故事汇            中国式相亲            老梁故事汇   0.057166     1   \n",
       "170               奔跑吧             天天向上            中国好声音   0.060634     2   \n",
       "865               钵钵鸡              钵钵鸡             麻婆豆腐   0.060634     2   \n",
       "478             快乐大本营            真正男子汉             笑傲江湖   0.058824     2   \n",
       "88                豆腐脑             麻婆豆腐              钵钵鸡   0.057166     1   \n",
       "231               钵钵鸡               火锅               烤肉   0.057166     1   \n",
       "\n",
       "     connect      score  \n",
       "154        4    1.01556  \n",
       "69         9   0.894055  \n",
       "232        9   0.881167  \n",
       "521        8   0.859456  \n",
       "213        6   0.857451  \n",
       "996        8   0.845482  \n",
       "713        3    0.84522  \n",
       "348        8   0.842444  \n",
       "799        9   0.841265  \n",
       "104        9   0.841265  \n",
       "51         5   0.839853  \n",
       "4          6   0.834757  \n",
       "148        9   0.834419  \n",
       "649        8   0.832904  \n",
       "829        9   0.832634  \n",
       "992        6   0.832634  \n",
       "156        8   0.828563  \n",
       "744        9   0.828563  \n",
       "330        8   0.827977  \n",
       "558        9   0.827977  \n",
       "985        2   0.825293  \n",
       "360        7    0.82186  \n",
       "704        8   0.821512  \n",
       "963        9   0.815477  \n",
       "737        7   0.814874  \n",
       "451        7   0.814874  \n",
       "636        8   0.813979  \n",
       "216        6   0.808753  \n",
       "313        8   0.808209  \n",
       "880        9   0.807774  \n",
       "..       ...        ...  \n",
       "581        2   0.336858  \n",
       "701        3   0.336858  \n",
       "946        3   0.336858  \n",
       "719        2   0.329478  \n",
       "598        1   0.323434  \n",
       "268        1   0.322827  \n",
       "327        1   0.322827  \n",
       "200        3   0.319313  \n",
       "752        2   0.303577  \n",
       "679        2   0.303577  \n",
       "510        2   0.303577  \n",
       "58         1   0.294904  \n",
       "583        2   0.280096  \n",
       "468        5   0.280096  \n",
       "542        2    0.27554  \n",
       "703        1    0.27554  \n",
       "167        2    0.27554  \n",
       "132        4    0.27554  \n",
       "347        1   0.268394  \n",
       "367        1   0.258102  \n",
       "657        1   0.258102  \n",
       "1          1   0.248461  \n",
       "41         2   0.231949  \n",
       "630        2   0.231949  \n",
       "690        4   0.226856  \n",
       "170        2   0.184012  \n",
       "865        1   0.123069  \n",
       "478        1   0.115904  \n",
       "88         1  0.0358276  \n",
       "231        1  0.0358276  \n",
       "\n",
       "[1000 rows x 22 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_data.sort_values('score',ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 结果\n",
    "可以看出id为10154的用户和10213、用户10036的推荐系数更高  \n",
    "10154的用户在相似度上与模拟用户更加接近，达到了0.647059，所以加权相加后，推荐系数为1.01556  \n",
    "10213的用户和10036的用户在用户价值和用户联系系数上更高，分别是9、9，推荐系数分别为0.894055、0.881167"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
